-- 부서 샘플
insert into st_dept values(st_seq_deptno.nextval, '기획부', 0, 30, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '총무부', 0, 36, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '경리부', 0, 48, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '고객만족실', 0, 50, 50, '');
insert into st_dept values(st_seq_deptno.nextval, 'IT사업부', 0, 20, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '기계사업부', 0, 41, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '기술연구부', 0, 38, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '관리본부', 0, 46, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '네트워크사업부', 0, 39, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '해외사업부', 0, 42, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '전략기획부', 0, 45, 50, '');
insert into st_dept values(st_seq_deptno.nextval, '법무부', 0, 41, 50, '');

-- 직급 샘플
insert into st_job values(st_seq_jobno.nextval, '사원', 10, '');
insert into st_job values(st_seq_jobno.nextval, '주임', 15, '');
insert into st_job values(st_seq_jobno.nextval, '대리', 20, '');
insert into st_job values(st_seq_jobno.nextval, '과장', 25, '');
insert into st_job values(st_seq_jobno.nextval, '차장', 30, '');
insert into st_job values(st_seq_jobno.nextval, '부장', 35, '');
insert into st_job values(st_seq_jobno.nextval, '상무', 40, '');
insert into st_job values(st_seq_jobno.nextval, '전무', 45, '');
insert into st_job values(st_seq_jobno.nextval, '사장', 50, '');

-- 유저 샘플
insert into st_user values(1020, 100, 10, 1111111, '조병훈', '1234', '111-1111', '111-111-1111', '111-2345', '11@111.com', '', '', sysdate);
insert into st_user values(1020, 100, 10, 2222222, '손병연', '1234', '222-2222', '222-2222-2222', '222-2345', '22@222.com', '', '', sysdate);

-- 주소록 분류 샘플
-- 개인 주소록용 분류 목록 샘플 데이터
insert into st_abcategory values(st_seq_ab_cno.nextval, '거래처', '거래처 연락', 1);
insert into st_abcategory values(st_seq_ab_cno.nextval, '혐업부서', '사내 혐업 부서', 1);
-- 부서 공용 주소록용 분류 목록 샘플 데이터
insert into st_abcategory values(st_seq_ab_cno.nextval, '주요 거래처', '전체 목록', 2);
insert into st_abcategory values(st_seq_ab_cno.nextval, '부서내', '부서 전원 목록', 2);

-- 주소록 샘플
insert into st_addrbook values(1111111, st_seq_addrno.nextval, 1, '홍길동', '과장', '활빈무역', '개발부', '', '222-2345', '222-2345-2345', '222-5432', '', '신촌', sysdate, '', '', 1);
insert into st_addrbook values(1111111, st_seq_addrno.nextval, 1, '김길동', '과장', '활빈무역', '개발부', '', '222-2345', '222-2345-2345', '222-5432', '', '신촌', sysdate, '', '', 2);

-- 업무 테이블 샘플
insert into st_settle values(st_seq_stno.nextval,'조장입니다','믿어주세요',sysdate,
			  1111111,2222222,1);
insert into st_settle values(st_seq_stno.nextval,'짱입니다','믿어주세요',sysdate,
			  2222222,1111111,1);

insert into st_workcall values(st_seq_wcno.nextval,'조장입니다','믿어주세요',sysdate,
			  1111111,2222222,2,'','',0);
insert into st_workcall values(st_seq_wcno.nextval,'짱입니다','믿어주세요',sysdate,
			  2222222,1111111,3,'','',0);
			  
insert into st_worksheet values(st_seq_wsno.nextval,'조장입니다','믿어주세요',sysdate,
			  1111111,2222222,1);
insert into st_worksheet values(st_seq_wsno.nextval,'짱입니다','믿어주세요',sysdate,
			  2222222,1111111,2);

insert into st_workreport values(st_seq_wrno.nextval,'조장입니다','믿어주세요',sysdate,
			  2222222,1111111,1);
insert into st_workreport values(st_seq_wrno.nextval,'짱입니다','믿어주세요',sysdate,
			  1111111,2222222,2);

-- 게시판 샘플
insert into st_article_tb values(st_seq_boardno.nextval, '테스트1', '테스트1', sysdate, 1111111, 0, 0, 0, 0, 0, 0, '', 0, '', 1, 1010);
insert into st_article_tb values(st_seq_boardno.nextval, '테스트2', '테스트2', sysdate, 1111111, 0, 0, 0, 0, 0, 0, '', 0, '', 1, 1010);
insert into st_article_tb values(st_seq_boardno.nextval, '테스트3', '테스트3', sysdate, 3333333, 0, 0, 0, 0, 0, 0, '', 0, '', 1, 1010);

-- 게시판 분류
insert into st_board_type values(st_seq_btype.nextval, '공지사항', 45, 0, 0);
insert into st_board_type values(st_seq_btype.nextval, '자유게시판', 45, 0, 0);
insert into st_board_type values(st_seq_btype.nextval, '공지사항', 45, 0, 1010);
insert into st_board_type values(st_seq_btype.nextval, '자유게시판', 45, 0, 1010);

-- 로그인 히스토리
insert into st_login_history values(st_seq_history.nextval, 1111111, sysdate, '211.238.142.98', '성공');